import pandas as pd
import numpy as np

data=pd.read_excel('scores.xlsx',header=[0,1],index_col=0)
print(data.head())

#最高
print(data.max())
#最低
print(data.min())
#一本分数线文科极差
print(np.ptp(data['一本分数线','文科']))
print((data.max()-data.min())['一本分数线','文科'])

#二本分数线理科2017-2018同比
print(data['二本分数线','理科'][2018]-data['二本分数线','理科'][2017])
#一本理科四分位数
print(data.describe()['一本分数线','理科']['25%'])
